Enterprise Manager

This article is about the Microsoft product. For the Oracle version, see Oracle Enterprise Manager.

Enterprise Manager is the primary administrative tool for Microsoft SQL Server 2000 and provides a MMC–based user interface that allows users to:

Define groups of servers running Microsoft SQL Server.
Register individual servers in a group.
Configure all Microsoft SQL Server options for each registered server.
Create and administer all Microsoft SQL Server databases, objects, logins, users, and permissions in each registered server.
Define and execute all Microsoft SQL Server administrative tasks on each registered server.
Design and test SQL statements, batches, and scripts interactively by invoking SQL Query Analyzer.
Invoke the various wizards defined for Microsoft SQL Server.

MMC is a tool that presents a common interface for managing different server applications in a Microsoft Windows network. Server applications provide a component called an MMC snap-in that presents MMC users with a user interface for managing the server application. Microsoft SQL Server Enterprise Manager is the Microsoft SQL Server 2000 MMC snap-in.

In Microsoft SQL Server 2005, Enterprise Manager is replaced by SQL Server Management Studio, which provides a single interface to functionality provided by Enterprise Manager and Query Analyzer in Microsoft SQL Server 2000.^[1]

This entire statement is taken from the following Microsoft Website: http://msdn.microsoft.com/en-us/library/aa174466(v=sql.80).aspx

References

^ "SQL Server Enterprise Manager". Redmond, WA, USA: Microsoft. http://msdn.microsoft.com/en-us/library/aa174466(v=sql.80).aspx. Retrieved November 10, 2011.